I noticed a long running query in one of my databases this morning. SELECT TABLESPACE, ROUND ( ( (max_size_mb – used_space + free_space_mb) / max_size_mb), :”SYS_B_00″) * :”SYS_B_01″ AS pct_free FROM ( SELECT ts.tablespace_name TABLESPACE, ROUND (SUM (NVL (fs.bytes, :”SYS_B_02″))) / :”SYS_B_03″ / :”SYS_B_04″ free_space_mb, ROUND (SUM (df.bytes)) / :”SYS_B_05″ / :”SYS_B_06″ used_space, ROUND ( … Continue reading DBSNMP long running query